SQL Server 2005Զ

һ.ʹSQL Server2005ԶݿĲ

1.Sql Server Agent 

2.ҵ

3.ӳ

4.Ӳ

5.Ӽƻ,Ƶ,ʱ

.ÿϸ

1.Sql Server Agent 

򿪡ùߡеġSQL Server Configuration ManagerڣSQL Serverùأ--SQL Server2005 񡿣洰ʾǵǰз״̬ҼSQL Server Agentѡ˵

2.ҵ

򿪡Management StudioչSQL ServerҼҵѡ½ҵ˵ѡҳѡ񡾳桿

3.ӳ

2еġѡҳѡ񡾳桿ѡҵJKTJAutoBack

4.Ӳ

2еġѡҳѡ񡾲衿·ġ½ť벽JKTJAutoBackѡݿJKTJSYSҵִеT-SQL䣬ﱸݵ£

****************************************************************

DECLARE @strPath NVARCHAR(200)

set @strPath = 'JKTJ_'+convert(NVARCHAR(10),DATEPART(weekday,getdate()-1),120)

set @strPath = REPLACE(@strPath, ':' , '-')

set @strPath = REPLACE(@strPath, '-' , '')

set @strPath = 'D:\' +'dbJKTJSYSBackup\' +@strPath + '-Auto_bak'

BACKUP DATABASE [JKTJSYS] TO DISK = @strPath WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

*****************************************************************
ע:Ҫÿ춼һļô˺:convert(NVARCHAR(10),getdate(),120)

5.Ӽƻ

2еġѡҳѡ񡾼ƻѡ½ť

JKTJAutoBackִƵʡÿƵʡ磺Ҫÿ賿Զݿ⣬ִƵѡÿ졢ÿƵѡִһΡִʱ䣺00000ʱ䣺ѡʼʱ䣬ѡʱ䡣SQL Serverÿ賿ԶִҵݿⱸݵD:\dbJKTJSYSBackup\Ŀ¼£ݵļΪJKTJ_2009-06-24-Auto_bak

*******************
ִҵɹԭ,ϸ鿴ԭ
1.޷򿪾ɱļȨ,ôҵ߶Ϊ:sa;ɾɵıļ.
2.SQL(SQL SERVER-MSSQLSERVER)ûʹû[LOCAL SYSTEM];
*******************

йWITH Ĳֵĺ壬οӻ棺

http://msdn.microsoft.com/zh-cn/library/ms186865.aspx

DATABASE [DatabaseName]DatabaseNameҪݵݿ⣬@strPathݵ·

ԭݿ⣺restore database [ݿ] from disk=[·]

* convert:飺յʽʱʽ

convert(NVARCHAR(19),getdate(),120)

磺SELECT CONVERT(nvarchar(19), getdate(), 120)

Ϊ2008-11-29 154559

磺'JKTJ_'+convert(NVARCHAR(10),getdate(),120)

ΪJKTJ_20180118

* REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )

õʽ滻һַʽгֵеڶַָʽƥ

滻':' Ϊ·':'ᱨ


ѡ

Ρ
 衡
 
BLOCKSIZE
 ָֽĴСûҪѡ
 
CHECKSUM | NO_CHECKSUM
 ʹCHECKSUMҳд뱸ļʱЧԼ⡣NO_CHECKSUMԼĬΪ
 
STOP_ON_ERROR | CONTINUE_AFTER_ERROR
 STOP_ON_ERRORѡ£CHECKSUM󣬽ֹͣCONTINUE_AFTER_ERROR£ʹ֤Ҳ
 
DESCRIPTION
 ָ˵ݼɸʽıʶ豸
 
EXPIREDATE | RETAINDAYS
 EXPIREDATEָݼںǵڡRETAINDAYSָ뾭ſԸǸñý弯
 
FORMAT | NOFORMAT
 FORMATڴ˱ݲодһµýͷеıͷᱻǡ豸дԺὲý弯òáNOFORMATָýͷдڴ˱ݲо
 
INIT | NOINIT
 INITָӦмеıݼǱýͷݼûйڣBACKUPеıݼ뱸ýϵƲƥ䣬ݼᱻǣNOINITʾݼ׷ӵ̻Ŵ豸ϣNOINITĬѡ
 
NOSKIP | SKIP
 NOSKIPƣȷϱݲᱻʵظǵĶİȫʩSKIPñݼĹںƼ
 
MEDIADESCRIPTION
 ý弯ɸʽı˵ʶý
 
MEDIANAME
 ý弯ƣΪ128ַ
 
NAME
 ݼ
 
NOREWIND | REWIND
 NOREWINDֹӦóSQL ServerBACKUPRESTORE֮ǰʹôŴʱŴ豸ָ֧ѡREWINDָSQL ServerƴŴͷſ
 
NOUNLOAD | UNLOAD
 UNLOADָڱɺԶƲжشŴNOUNLOAD˼ǴŴڱɺӴŴ豸жأҿԱݲʹ
 
STATS
 ڱݹзطͻˡĬΪÿ10%ͷϢ
 
COPY_ONLY
 SQL Server 2005ѡ㴴һƻеݿⱸݣ磬ݺ־ݵ־
 
